<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class chk_status_model extends CI_Model
{
	
	public function __construct()
	{
		parent::__construct();

	}
	
	
public function get_detail($id)
{


$this->db->select('case.id,case.case_no,case.date,status.name as status,customer.customer_name,customer.mobile');
	$this->db->from('case','customer' );
	$this->db->join('customer','customer.service_id=case.service_id');
	$this->db->join('status', 'status.id= case.status_id  '  );
	$this->db->where('case.case_no',$id);
	$q = $this->db->get();
	return $q->result();
}		
	
	
	
}?>	